Part 1: Measuring Sea Level Rise Over Time

Redwood City, adjacent to East Palo Alto, Palo Alto, and Foster City, has a large portion of its boundary on the coast. With climate change intensifying, we wondered what the implications of sea level rise would be on this more vulnerable area.


Map of Redwood City’s Boundaries


In the image below, we can see a map of a portion of the Redwood City flood basin.

Next, we processed flood maps for nine hazard scenarios collected from OCOF, cropped to the extent of the Redwood City cbgs under consideration. These hazard scenarios consisted of sea level rise of 0cm, 25cm and 50cm, and then return periods of 1 year, 20 years, and 100 years. All combinations of these factors resulted in nine hazard scenarios.

Part 2: Vehicle Exposure in Redwood City

In order to examine vehicle exposure, we began by calculating the maximum flood event (sea level rise of 50cm with a return period of 100 years).

Next, we calculated the building exposure for Redwood City. Our assumption is that vehicle exposure will be the same as building exposure since vehicles are usually parked next to buildings.

We then used EMFAC to collect vehicle counts in San Mateo County (where Redwood City is located) for the years 2020, 2030, 2040, and 2050.

This served as an estimate of the percent increase in vehicles decade by decade. We then collected the latest available (2019) ACS 5-yr data about vehicle ownership and population in our specific Redwood City CBGs in order to produce an estimate of the total number of owned vehicles.

This is what was used for 2020, to be scaled to 2030 and on using the EMFAC percentages. We are making the assumption here that the percent vehicle ownership rate doesn’t change over the next 30 years.

Out of total households, 81 households did not have any vehicles available in 2020. 919 of them had one vehicle.

The vehicle projection for the Redwood City cbgs for the years 2030, 2040 and 2050 are portrayed in the table below, including a breakdown of households with one vehicle vs zero vehicles.

vehicle_count year no_vehicles one_vehicle
5645.000 2020 81.0000 919.000
7997.906 2030 114.7618 1302.051
9487.590 2040 136.1372 1544.569
10106.098 2050 145.0122 1645.262


We are assuming that each city in San Mateo is increasing vehicle count by the same amount each decade. Thus, we are able to use EMFAC data to determine how many vehicles there will be in our flood risk zone between 2020-2050.

Based on this vehicle projection, in 2020 there is expected to be around 5,600 cars, in 2030 there is expected to be about 8,000 vehicles, in 2030 there is expected be 9,500 cars, and in 2050 there is expected to be around 10,100 vehicles.

Households with no vehicles in our study area are also projected to increase by the same percentage, as are households with one vehicle. The number of households with no vehicle is consistently less than those with one vehicle over this timeframe.

When determining flood risk for these vehicles, it is important to remember that we are using household flood risk as our test, so it will look like there is little to no risk for those households with 1/0 vehicles. Obviously, this is not the case, however, this particular model is looking at vehicle-related flood damage and thus cannot capture accurately the damage incurred by households. Households with no vehicles might merely live closer to public transportation hubs, or might not be able to afford a vehicle. If the latter is the case, this group would be even more vulnerable to monetary damages caused by sea level rise, per the assumption we made about vehicle flood risk being the same as building flood risk.


Part 3: Vehicles per Building

After using 2020 Decennial census data to calculate the total population in each block, we used OpenStreetMap data to retrieve all residential building footprints within these blocks. Assuming population is distributed evenly across buildings in a block, and vehicles are distributed evenly across population, 2020 vehicles were allocated from the whole CBG to each building.

Part 4: Vulnerability Data

Here, we estimate percent vehicle damage for individual vehicles using vulnerability data from the US Army Corps of Engineers (https://planning.erdc.dren.mil/toolbox/library/EGMs/egm09-04.pdf).


Building damage is used as a proxy for vehicle damage by assuming that street level or basement flooding would affect cars as well as houses.

The more flood depth, the greater the vehicle flood damage as can be seen in this plot.

Part 5: Average Annualized Cost of Floods


Risk Estimation

From the New York Times (https://www.nytimes.com/2021/03/25/business/car-paint-job-resale-value.html), the average resale value of a sedan in 2020 was $24,112, which was our vehicle cost assumption. This number was then multiplied by the percentage of respondents who would not move their vehicles with warning greater than 12 hours (11.9%), a value from the Army Corps of Engineers. These values were then multiplied by the damage percentage.


This output of vehicle damage in Redwood City shows that OSM 233058123 has the highest $ damage risk, with a value of $18,676.


Now we have “$ damage” for each vehicle, for each event. We can now combine each trio of storm events together (for each of 5 levels of sea level rise). The result will be an “average annualized loss” for each vehicle for 5 different hypothetical years, each of which has a different base sea level rise.


The output of vehicle average annualized loss by sea level rise in Redwood City shows that OSM 233058123 has the highest average annualized loss related to flood risk, with a value of $19,337.


Next, we estimate average annualized loss, in $ vehicle damages, over 2020-2050, using RCP 4.5 occurrence rates of sea level rise in the Bay Area across years.


SLR 2020 2030 2040 2050 2060 2070 2080 2090 2100
0 0.942 0.923 0.793 0.508 0.235 0.094 0.033 0.011 0.005
25 0.000 0.051 0.198 0.453 0.581 0.440 0.249 0.128 0.071
50 0.000 0.000 0.001 0.035 0.176 0.363 0.409 0.313 0.190
75 0.000 0.000 0.000 0.000 0.007 0.099 0.224 0.296 0.290
100 0.000 0.000 0.000 0.000 0.000 0.004 0.075 0.162 0.219
125 0.000 0.000 0.000 0.000 0.000 0.000 0.010 0.064 0.126
150 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.025 0.055
175 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.001 0.034
200 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.010
500 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000


Now we have projected flood risk between 2020-2050 and its associated $ damage. It seems like 2020 and 2030 are going to be the most costly years with their associated osm_id’s.

The total average annualized loss for all of our study areas in Redwood City is presented in the table below for each year:

year damage
2020 28095.43
2030 289945.20
2040 1049333.57
2050 2587135.52


The damage increases exponentially each decade.


It is quite evident that there is a clear flood risk in this zone that is only exacerbated over the 2020-2050 timeframe (seen through toggling between 2020 and 2050 on the map). Overall, most locations have low flood risk in 2020, indicated by a pale red color, which becomes much greater when toggled to 2050, indicated by a darker red on the map.

The buildings and vehicles in the inlet close to the Bayshore Freeway are seemingly the most exposed in the study area, with some areas being bright red in the change between 2020 and 2050. The section with Satuma Dr in the center seems to be most at risk in 2050 with the greatest change between 2020 and 2050. The Redwood Shores Lagoon neighborhood is at serious risk of flood damage though none of the buildings seem to have as urgent or dire a flood risk as the Maple St neighborhood. There does seem to be a fair amount of buffer zone between the water and housing, which may be attributed to the fact that we did not include industrial use buildings. Perhaps if we did there would be greater red zones.

Obviously there are many assumptions we made in our study and a lot of projection, but based on this analysis, Redwood City should act quickly to strengthen its climate change/sea level rise mitigation plans.

Below, we have a table illustrating the average annualized loss for each of our three studied cbgs in Redwood City, over the 2020-2050 timeframe:

GEOID aal
060816103021 45369.55
060816103032 346567.91
060816103034 490360.62

It is clear that the cost of damage associated with increasing levels of sea rise are increasing as well.

The sum value of all the average annualized loss across all our studied cbgs in Redwood City over the 2020-2050 timeframe:

x
$882,298.1

Below, the AAL across our block groups is plotted.

The darkest chunk has the greatest loss, the orange has slightly less loss, and the white chunk has the least amount of loss. However, the orange chunk has the greatest amount of buildings, followed by the darkest and then the white. This is likely due to the fact that the white chunk is the most inland versus the darkest chunk which is closest to the water and the canals. Waterfront properties generally are more expensive than inland ones so perhaps more people own more vehicles there, which would contribute to a greater AAL.

We can see that even at the block level, there are large variations in locations of buildings relative to the coast. For example, in the largest block, buildings and vehicles close to the water will have drastically different outcomes than more inland locations. Thus, our results may not be granular enough to fully understand the placement of the buildings and their associated AALs. Future assessment might include more nuanced analysis.

This analysis was a starting point to understand how sealevel rise will affect blocks within Redwood City, but further analysis should include cost of housing, housing tenancy, and the effects of average annualized loss on communities. It would be interesting to also better understand the demographics of this area and how that might play into specific vulnerabilities that become exacerbated with effects of climate change/sea level rise.

(This assignment was completed in partnership with Daphne Jacobsberg and Catherine Beck)